OpenEdge Data Management:<br />Database Administration Enabling your database for automated AI file management

If you have enabled after imaging for your database, the following example demonstrates the steps to automate your AI file management. If you do not have after imaging enabled, see "Enabling after-imaging" section. The example uses a database named mydb.

Create directories on disks with sufficient space to archive your AI extents.

Enable your database for AI file management:


rfutil mydb -C aiarchiver enable

Start your database broker with AI file management parameters:


proserve mydb -S 6931 -aiarcdir /usr1/aiarchives/mydb/,/usr2/aiarchives/mydb/ -aiarcinterval 120

In this example, two directories are specified as output destinations for the archived AI files, /usr1/aiarchives/mydb and /usr2/aiarchives/mydb. If you do not create the directories, you can add an additional parameter, -aiarcdircreate, to instruct the AI file management utility to create the archive directories. The -aistall parameter is implicitly

Setting -aiarchinterval to 120 directs the daemon to waken and archive extents every 2 minutes. You can specify an interval as small as 1 minute, and as large as 24 hours. If you specify 0, the daemon, will waken each time an archive fills, regardless of the amount of elapsed time.

If you are unsure of a time interval, you can initially set -aiarchinterval to 0, and then switch to a timed interval based on the frequency of archives as recorded in the archive log file.